#!/bin/bash
source /etc/profile

#该脚本删除2天前表的partition

usage_of_vertica=`/opt/vertica/bin/vsql -At -U dbadmin -w Password1  -c "SELECT DROP_PARTITION('action_log',TO_CHAR(DATE(CURRENT_DATE + INTERVAL '-2 day')));"`

